package com.mmy.dao.visa;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import com.mmy.domain.visa.VVisaCollection;

/**
 * 类的介绍：dao层 签证收集信息
 *
 * @author hanxl
 * @date 2020-07-23
 * @version 1.0
 */

public interface VVisaCollectionRepository
		extends JpaRepository<VVisaCollection, Integer>, JpaSpecificationExecutor<VVisaCollection> {
	/* 通过订单号获得材料整理表 */
	@Query(value = "select *from vVisaCollection where cOrderID=?1 ", nativeQuery = true)
	List<VVisaCollection> findByOrderID(String cOrderID);

}
